Creating calculating columns for (Full Payment, Partial Payment, No Payment) and grouping column for Class Start Date 11

creating measure in power bi using DAX


Steps     Creating calculating columns for (full Payment, Partial Payment, and No                            Payment)

  1. Click on Transform data
  2. Press and hold control button and select FullPayPer and TotalEnr.
  3. Go to Add Column and click on Standard and apply math operation multiplication
  4. New column is created and name that "Full Payment" 
  5. Repeat the step 2,3 PartialPayPer, NoPayPer. And give column name Partial Payment and No payment.

Follow the Gif bellow.



Grouping Class Start Date





Steps 
  1.  Click on the Data view.
  2. Select the column CSD
  3. Right click on the mouse and select New group
  4. Select the group type to List.
  5. Click on Ungrouped values and select Group
  6. Double click on Group member and change the format date example Jan 29 2022 to 01/29/2022. Repeat these to all dates.
Follow the Gif bellow